<?php
/* 
 * this deletes all the unconfirmed registration older than 1 hour.  cron schedule every hour. 
 */
require_once '/home/alexinaustin/public_html/providerConstants.php';
$mysqli = new mysqli($dbHost,$dbUser,$dbPass,$db);
$deleteSql = 'delete FROM provider_master WHERE insertTs < (NOW() - INTERVAL 1 hour) and tempToken is not null';
$stmt = $mysqli->prepare($deleteSql);
$stmt->execute();
?>
